package com.gs.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.gs.pojo.Predetermine;

public interface PredetermineDao {

	//查找所有
	List<Predetermine> selectall();

	//修改预定到时
	int updateRemind(Integer id);
	
	//分页模糊查询
	List<Predetermine> pageFuzzyselect(@Param("receiveTeamName")String receiveTeamName,
   		 							   @Param("passengerName")String passengerName, 
   		 							   @Param("predetermineStateID")int predetermineStateID,
   		 							   @Param("start")int start,
   		 							   @Param("pageSize")int pageSize);

	//查找总数
	int countFuzzyselect(@Param("receiveTeamName")String receiveTeamName,
						 @Param("passengerName")String passengerName, 
						 @Param("predetermineStateID")int predetermineStateID);

	//根据id删除
	int deleteById(Integer id);

	//新增预订
	int insertAll(Predetermine predetermine);

	//根据预订id来查询预订数据
	Predetermine findById(Integer id);

	//根据 团队id 来查询
	List<Predetermine> findTeamId(int id);

	//根据 旅客id 来查询
	List<Predetermine> findLvKeId(int id);

	//根据id修改预订状态
	int updatePredetermineStateID(int id);

}
